{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["NC-REGISTER","NC LIVE PROCESS","QUALITY RISK COPQ MATRIX","NC DASHBOARD","NC ANALYSES"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":5,"defined_names":215,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"NC-REGISTER","index":0,"n_rows":13,"n_cols":123,"rows_kept":13,"cut":false,"hidden":false,"merged":[[6,1,6,122],[0,1,3,3],[0,5,1,13],[2,5,3,13],[7,0,7,19],[7,20,7,23],[7,119,7,122],[7,88,7,94],[7,65,7,76],[7,33,7,53],[7,112,7,117],[7,102,7,104]]}
[null,null,null,null,null,"NON CONFORMANCE RISK SYSTEM"]
[]
[]
[]
[]
[]
[]
["ORIGINATED (DETEECTION)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GATE REVIEW CONTROL",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,AD10:AD1048576)","v":0},{"$f":"SUBTOTAL(9,AE10:AE1048576)","v":0},{"$f":"SUBTOTAL(9,AF10:AF1048576)","v":1},null,"NC QUALITY ANALYSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,BK10:BK1048576)","v":0},{"$f":"SUBTOTAL(9,BL10:BL1048576)","v":1},null,"CORRECTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,CH10:CH1048576)","v":0},{"$f":"SUBTOTAL(9,CI10:CI1048576)","v":1},null,"PREVENTION",null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,CV10:CV1048576)","v":0},{"$f":"SUBTOTAL(9,CW10:CW1048576)","v":0},null,"QUALITY VALIDATION",null,null,null,null,null,null,{"$f":"SUBTOTAL(9,DF10:DF1048576)","v":0},{"$f":"SUBTOTAL(9,DG10:DG1048576)","v":0},null,"NON CONFORMANCE TIME CYCLE (DAYS)",null,null,null,null,null,null,"QUALITY RISK MATRIX"]
["NC RAISED BY:",{"$f":"A9","v":"NC RAISED BY:"},"YOUR DEPARTMENT:",{"$f":"C9","v":"YOUR DEPARTMENT:"},"PROCESS EFFECTED:",{"$f":"E9","v":"PROCESS EFFECTED:"},"NC DATE RAISED:",{"$f":"G9","v":"NC DATE RAISED:"},"INTERNAL / SUPPLIER:",{"$f":"I9","v":"INTERNAL / SUPPLIER:"},"DEPARTMENT / SUPPLIER NAME:",{"$f":"K9","v":"DEPARTMENT / SUPPLIER NAME:"},"WHEN WAS IT DETECTED:",{"$f":"M9","v":"WHEN WAS IT DETECTED:"},"HOW WAS IT DETECTED:",{"$f":"O9","v":"HOW WAS IT DETECTED:"},"NC DEFECT TYPE:",{"$f":"Q9","v":"NC DEFECT TYPE:"},"QUICK FIX SOLUTION:",{"$f":"S9","v":"QUICK FIX SOLUTION:"},"BLANK / REVIEWED","IF NO","IF YES","GATE SCORE","TODAY"," BALANCE","OPEN (DAYS)","CLOSED (DAYS)","GATE REVIEW 1","NOT REVIEWED BY QUALITY","REJECTED BY QUALITY","APPROVED BY QUALITY","NC ACCEPTED:",{"$f":"AG9","v":"NC ACCEPTED:"},"NC DATE REVIEWED:",{"$f":"AI9","v":"NC DATE REVIEWED:"},"NC NUMBER",{"$f":"AK9","v":"NC NUMBER"},"DEPARTMENT:",{"$f":"AM9","v":"DEPARTMENT:"},"PROCESS:",{"$f":"AO9","v":"PROCESS:"},"PROCESS STEP:",{"$f":"AQ9","v":"PROCESS STEP:"},"RELATED TO:",{"$f":"AS9","v":"RELATED TO:"},"CATEGORY:",{"$f":"AU9","v":"CATEGORY:"},"ORIGIN:",{"$f":"AW9","v":"ORIGIN:"},"NC LEVEL:",{"$f":"AY9","v":"NC LEVEL:"},"DATE DISPOSITION:",{"$f":"BA9","v":"DATE DISPOSITION:"},"IF YES","COMPLETED","GATE SCORE","TODAY"," BALANCE","OPEN (DAYS)","CLOSED (DAYS)","GATE REVIEW 2","UNDER INVESTIGATION","INVESTIGATION COMPLETED","ACTION TO BE TAKEN:",{"$f":"BM9","v":"ACTION TO BE TAKEN:"},"PROCESS OWNER:",{"$f":"BO9","v":"PROCESS OWNER:"},"DUE COMPLETION DATE:",{"$f":"BQ9","v":"DUE COMPLETION DATE:"},"COMPLETION DATE:",{"$f":"BS9","v":"COMPLETION DATE:"},"ZAR COST:",{"$f":"BU9","v":"ZAR COST:"},"RISK LEVEL","MAN POWER HOURS:",{"$f":"BX9","v":"MAN POWER HOURS:"},"INVESTIGATION COMPLETED","COMPLETED","GATE SCORE","TODAY"," BALANCE","OPEN (DAYS)","CLOSED (DAYS)","GATE REVIEW 3","BUSY IMPLEMENTING","ACTION IMPLEMENTED","PREVENTIVE  TAKEN:",{"$f":"CJ9","v":"PREVENTIVE  TAKEN:"},"ZAR VALUE:",{"$f":"CL9","v":"ZAR VALUE:"},"MAN POWER HOURS:",{"$f":"CN9","v":"MAN POWER HOURS:"},"COMPLETION DATE:",{"$f":"CP9","v":"COMPLETION DATE:"},"IMPLEMENTING","COMPLETED","GATE SCORE","GATE REVIEW 4","BUSY IMPLEMENTING","PREVENTION IMPLEMENTED","VALIDATED BY",{"$f":"CX9","v":"VALIDATED BY"},"VALIDATION DATE:",{"$f":"CZ9","v":"VALIDATION DATE:"},"VALIDATE NC","NC CLOSED OUT","GATE SCORE","GATE REVIEW 5","NC CLOSED OUT","VALIDATE NC",null,"GATE REVIEW 1","GATE REVIEW 2","GATE REVIEW 3","GATE REVIEW 4","GATE REVIEW 5","TOTAL DAYS FOR NC",null,"SEVERITY","COST IMPACT","MATRIX","RISK SCORE"]
[{"$f":"[5]NC!$C$6","v":"CHAD REEVELL"},{"$f":"IF(A10=0,\"\",A10)","v":"CHAD REEVELL"},{"$f":"[5]NC!$I$6","v":"5. PROCUREMENT"},{"$f":"IF(C10=0,\"\",C10)","v":"5. PROCUREMENT"},{"$f":"[5]NC!$I$7","v":"1.1 RECEIVING"},{"$f":"IF(E10=0,\"\",E10)","v":"1.1 RECEIVING"},{"$f":"[5]NC!$C$7","v":41526},{"$f":"IF(G10=0,\"\",G10)","v":"2013-09-09"},{"$f":"[5]NC!$C$11","v":"INTERNAL"},{"$f":"IF(I10=0,\"\",I10)","v":"INTERNAL"},{"$f":"[5]NC!$I$11","v":"ENTER DEPARMENT NAME"},{"$f":"IF(K10=0,\"\",K10)","v":"ENTER DEPARMENT NAME"},{"$f":"[5]NC!$C$9","v":"AFTER OPERATIONS"},{"$f":"IF(M10=0,\"\",M10)","v":"AFTER OPERATIONS"},{"$f":"[5]NC!$I$9","v":"OBSERVATION"},{"$f":"IF(O10=0,\"\",O10)","v":"OBSERVATION"},{"$f":"[5]NC!$C$24","v":"DEFECTIVE PRODUCT"},{"$f":"IF(Q10=0,\"\",Q10)","v":"DEFECTIVE PRODUCT"},{"$f":"[5]NC!$I$24","v":"NO"},{"$f":"IF(S10=0,\"\",S10)","v":"NO"},{"$f":"IF(H10=\"\",0,1)","v":1},{"$f":"IF(AH10=\"NO\",1,0)","v":0},{"$f":"IF(AH10=\"YES\",2,0)","v":2},{"$f":"SUM(U10:W10)","v":3},{"$f":"TODAY()","v":"2013-10-15"},{"$f":"IF(H10=\"\",\"\",Y10-H10)","v":36},{"$f":"IF(AJ10=\"\",Z10,\"\")","v":""},{"$f":"IF(AJ10=\"\",\"\",AJ10-H10)","v":4},{"$f":"IF(X10=0,\"\",IF(X10=1,\"NOT REVIEWED BY QUALITY\",IF(X10=2,\"REJECTED BY QUALITY\",IF(X10=3,\"APPROVED BY QUALITY\"))))","v":"APPROVED BY QUALITY"},{"$f":"IF(AC10=\"NOT REVIEWED BY QUALITY\",1,0)","v":0},{"$f":"IF(AC10=\"REJECTED BY QUALITY\",1,0)","v":0},{"$f":"IF(AC10=\"APPROVED BY QUALITY\",1,0)","v":1},{"$f":"[5]NC!$C$30","v":"YES"},{"$f":"IF(AG10=0,\"\",AG10)","v":"YES"},{"$f":"[5]NC!$I$30","v":41530},{"$f":"IF(AI10=0,\"\",AI10)","v":"2013-09-13"},{"$f":"[5]NC!$C$31","v":"0001"},{"$f":"IF(AK10=0,\"\",AK10)","v":"0001"},{"$f":"[5]NC!$C$33","v":"5. PROCUREMENT"},{"$f":"IF(AM10=0,\"\",AM10)","v":"5. PROCUREMENT"},{"$f":"[5]NC!$C$34","v":"1.3 PRODUCTION / MANUFACTURING"},{"$f":"IF(AO10=0,\"\",AO10)","v":"1.3 PRODUCTION / MANUFACTURING"},{"$f":"[5]NC!$C$35","v":"27"},{"$f":"IF(AQ10=0,\"\",AQ10)","v":"27"},{"$f":"[5]NC!$C$37","v":"1.PRODUCT"},{"$f":"IF(AS10=0,\"\",AS10)","v":"1.PRODUCT"},{"$f":"[5]NC!$C$38","v":"1.2 VISUAL"},{"$f":"IF(AU10=0,\"\",AU10)","v":"1.2 VISUAL"},{"$f":"[5]NC!$C$39","v":"1.2.2 SCRATCHES / DENTS / HAMMER MARKS"},{"$f":"IF(AW10=0,\"\",AW10)","v":"1.2.2 SCRATCHES / DENTS / HAMMER MARKS"},{"$f":"[5]NC!$C$40","v":"CRITICAL"},{"$f":"IF(AY10=0,\"\",AY10)","v":"CRITICAL"},{"$f":"[5]NC!$C$42","v":41530},{"$f":"IF(BA10=0,\"\",BA10)","v":"2013-09-13"},{"$f":"IF(AH10=\"YES\",1,\"\")","v":1},{"$f":"IF(BB10=\"\",0,1)","v":1},{"$f":"SUM(BC10:BD10)","v":2},{"$f":"TODAY()","v":"2013-10-15"},{"$f":"IF(AJ10=\"\",\"\",BF10-AJ10)","v":32},{"$f":"IF(BB10=\"\",BG10,\"\")","v":""},{"$f":"IF(BB10=\"\",\"\",BB10-AJ10)","v":0},{"$f":"IF(BE10=0,\"\",IF(BE10=1,\"UNDER INVESTIGATION\",IF(BE10=2,\"INVESTIGATION COMPLETED\")))","v":"INVESTIGATION COMPLETED"},{"$f":"IF(BJ10=\"UNDER INVESTIGATION\",1,0)","v":0},{"$f":"IF(BJ10=\"INVESTIGATION COMPLETED\",1,0)","v":1},{"$f":"[5]NC!$C$43","v":"SCRAP"},{"$f":"IF(BM10=0,\"\",BM10)","v":"SCRAP"},{"$f":"[5]NC!$C$44","v":"ANNANDA HOW"},{"$f":"IF(BO10=0,\"\",BO10)","v":"ANNANDA HOW"},{"$f":"[5]NC!$C$45","v":41552},{"$f":"IF(BQ10=0,\"\",BQ10)","v":"2013-10-05"},{"$f":"[5]NC!$H$56","v":41530},{"$f":"IF(BS10=0,\"\",BS10)","v":"2013-09-13"},{"$f":"[5]NC!$C$61","v":675765},{"$f":"IF(BU10=0,\"\",BU10)","v":675765},{"$f":"IF(BV10<100,1,IF(BV10<101>1000,2,IF(BV10<1001>10000,3,IF(BV10<10001>100000,4,IF(BV10<100001>1000000,5,IF(BV10<1000001>10000000,6,\"\"))))))","v":2},{"$f":"[5]NC!$I$61","v":"5"},{"$f":"IF(BX10=0,\"\",BX10)","v":"5"},{"$f":"IF(BJ10=\"INVESTIGATION COMPLETED\",1,0)","v":1},{"$f":"IF(BT10=\"\",0,1)","v":1},{"$f":"SUM(BZ10:CA10)","v":2},{"$f":"TODAY()","v":"2013-10-15"},null,null,null,{"$f":"IF(CB10=0,\"\",IF(CB10=1,\"BUSY IMPLEMENTING\",IF(CB10=2,\"ACTION IMPLEMENTED\")))","v":"ACTION IMPLEMENTED"},{"$f":"IF(CG10=\"BUSY IMPLEMENTING\",1,0)","v":0},{"$f":"IF(CG10=\"ACTION IMPLEMENTED\",1,0)","v":1},{"$f":"[5]NC!$C$70","v":0},{"$f":"IF(CJ10=0,\"\",CJ10)","v":""},{"$f":"[5]NC!$C$74","v":0},{"$f":"IF(CL10=0,\"\",CL10)","v":""},{"$f":"[5]NC!$I$74","v":0},{"$f":"IF(CN10=0,\"\",CN10)","v":""},{"$f":"[5]NC!$H$80","v":0},{"$f":"IF(CP10=0,\"\",CP10)","v":""},{"$f":"IF(CG10=\"BUSY IMPLEMENTING\",0,IF(CG10=\"ACTION IMPLEMENTED\",1,\"\"))","v":1},{"$f":"IF(CQ10=\"\",0,1)","v":0},{"$f":"SUM(CR10:CS10)","v":1},{"$f":"IF(CT10=0,\"\",IF(CT10=1,\"BUSY IMPLEMENTING\",IF(CT10=2,\"PREVENTION IMPLEMENTED\")))","v":"BUSY IMPLEMENTING"},{"$f":"IF(CU10=\"BUSY IMPLEMETING\",1,0)","v":0},{"$f":"IF(CU10=\"PREVENTION IMPLEMENTED\",1,0)","v":0},{"$f":"[5]NC!$C$84","v":0},{"$f":"IF(CX10=0,\"\",CX10)","v":""},{"$f":"[5]NC!$H$84","v":"00:00:00"},{"$f":"IF(CZ10=0,\"\",CZ10)","v":""},{"$f":"IF(CU10=\"BUSY IMPLEMENTING\",\"\",IF(CU10=\"PREVENTION IMPLEMENTED\",1,\"\"))","v":""},{"$f":"IF(DA10=\"\",0,1)","v":0},{"$f":"SUM(DB10:DC10)","v":0},{"$f":"IF(DD10=1,\"VALIDATE NC\",IF(DD10=2,\"NC CLOSED OUT\",\"\"))","v":""},{"$f":"IF(DE10=\"NC CLOSED OUT\",1,0)","v":0},{"$f":"IF(DE10=\"VALIDATE NC\",1,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AZ10=\"LOW / INSIGNIFICATE\",\"A\",IF(AZ10=\"MINIMAL\",\"B\",IF(AZ10=\"MEDIUM / MODERATE\",\"C\",IF(AZ10=\"CRITICAL\",\"D\",IF(AZ10=\"VERY CRITICAL\",\"E\",IF(AZ10=\"CATASTROPHIC\",\"F\",\"\"))))))","v":"D"},6,{"$f":"DQ10&DP10","v":"6D"},{"$f":"IF(DR10=\"1A\",1,IF(DR10=\"2A\",3,IF(DR10=\"3A\",9,IF(DR10=\"4A\",11,IF(DR10=\"5A\",13,IF(DR10=\"6A\",17,IF(DR10=\"1B\",4,IF(DR10=\"2B\",12,IF(DR10=\"3B\",36,IF(DR10=\"4B\",44,IF(DR10=\"5B\",52,IF(DR10=\"6B\",68,IF(DR10=\"1C\",6,IF(DR10=\"2C\",18,IF(DR10=\"3C\",54,IF(DR10=\"4C\",66,IF(DR10=\"5C\",78,IF(DR10=\"6C\",102,IF(DR10=\"1D\",8,IF(DR10=\"2D\",24,IF(DR10=\"3D\",72,IF(DR10=\"4D\",88,IF(DR10=\"5D\",104,IF(DR10=\"6D\",136,IF(DR10=\"1E\",10,IF(DR10=\"2E\",30,IF(DR10=\"3E\",90,IF(DR10=\"4E\",110,IF(DR10=\"5E\",130,IF(DR10=\"6E\",170,IF(DR10=\"1F\",14,IF(DR10=\"2F\",42,IF(DR10=\"3F\",126,IF(DR10=\"4F\",154,IF(DR10=\"5F\",182,IF(DR10=\"6F\",238,\"\"))))))))))))))))))))))))))))))))))))","v":136}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X12=0,\"\",IF(X12=1,\"NOT REVIEWED BY QUALITY\",IF(X12=2,\"REJECTED BY QUALITY\",IF(X12=3,\"APPROVED BY QUALITY\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"NC LIVE PROCESS","index":1,"n_rows":9,"n_cols":24,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,9,3,11],[3,13,3,15],[3,17,3,19],[3,21,3,23],[3,5,3,7],[4,1,5,3],[4,9,5,11],[4,13,5,15],[4,17,5,19],[4,21,5,23],[4,5,5,7],[10,0,10,25],[6,21,6,22],[7,21,7,22],[8,5,8,6],[6,5,6,6],[7,5,7,6],[6,13,6,14],[7,13,7,14],[6,1,6,2],[6,9,6,10],[7,9,7,10],[6,17,6,18],[7,17,7,18]]}
[]
[]
[]
[null,"DETECTION / RAISED",null,null,null,"GATE REVIEW 1",null,null,null,"GATE REVIEW 2",null,null,null,"GATE REVIEW 3",null,null,null,"GATE REVIEW 4",null,null,null,"GATE REVIEW 5"]
[null,"ORIGINATE OF NC\n(DETECTION LEVEL)",null,null,null,"QUALITY NC APPROVAL",null,null,null,"QUALITY ANALYSES",null,null,null,"CORRECTIVE ACTION",null,null,null,"PREVENTIVE ACTION",null,null,null,"VERIFICATION AND \nCLOSE OUT"]
[]
[null,"NC SUBMITTED",null,{"$f":"SUM('NC-REGISTER'!AD8:AF8)","v":1},null,"NC NOT REVIEWED",null,{"$f":"'NC-REGISTER'!AD8","v":0},null,"UNDER INVESTIGATION",null,{"$f":"'NC-REGISTER'!BK8","v":0},null,"BUSY IMPLEMENTING",null,{"$f":"'NC-REGISTER'!CH8","v":0},null,"BUSY IMPLEMENTING",null,{"$f":"'NC-REGISTER'!CV8","v":0},null,"VALIDATE NC",null,{"$f":"'NC-REGISTER'!DG8","v":0}]
[null,null,null,null,null,"NC APPROVED",null,{"$f":"'NC-REGISTER'!AF8","v":1},null,"INVESTIGATION DONE",null,{"$f":"'NC-REGISTER'!BL8","v":1},null,"IMPLEMENTED",null,{"$f":"'NC-REGISTER'!CI8","v":1},null,"IMPLEMENTED",null,{"$f":"'NC-REGISTER'!CW8","v":0},null,"NC CLOSED OUT",null,{"$f":"'NC-REGISTER'!DF8","v":0}]
[null,null,null,null,null,"NC REJECTED",null,{"$f":"'NC-REGISTER'!AE8","v":0}]

{"sheet":"QUALITY RISK COPQ MATRIX","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"NC DASHBOARD","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"NC ANALYSES","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}